﻿SELECT 
	'Southeast' REGION,	
	CASE STATE_CD 
	WHEN 'AL' THEN 'ALM' 
	WHEN 'LA' THEN 'ALM' 
	WHEN 'MS' THEN 'ALM' 
	WHEN 'KY' THEN 'KTNS' 
	WHEN 'TN' THEN 'KTNS' 
	WHEN 'SC' THEN 'KTNS' 
	WHEN 'NC' THEN 'KTNS' 
	ELSE STATE_CD
	END MARKET,	
	STATE_CD, 
	TRAC_ID, 
	TRAC_NUM, 
	ACCT_MGR, 
	AREA_MGR, 
	PORTFOLIO_NM, 
	PROPERTY_NM, 
	ADDRESSES, 
	GREENS, 
	SUBSCRIBERS, 
	HSIA, 
	IPTV, 
	VOIP, 
	HSIA_REVENUE, 
	IPTV_REVENUE, 
	VOIP_REVENUE, 
	OTHER_UVERSE_REVENUE, 
	TOTAL_REVENUE
FROM 
	SUNRISE_TEST.ACC_TRAC_ID_SUMMARY
